﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmDjkOrdersDetail" targetNamespace="http://tempuri.org/CDmDjkOrdersDetail.xsd" xmlns:mstns="http://tempuri.org/CDmDjkOrdersDetail.xsd" xmlns="http://tempuri.org/CDmDjkOrdersDetail.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="dijiekeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dijiekeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.dijiekeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DJK_ORDERS_DETAILTableAdapter" GeneratorDataComponentClassName="DJK_ORDERS_DETAILTableAdapter" Name="DJK_ORDERS_DETAIL" UserDataComponentName="DJK_ORDERS_DETAILTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dijiekeConnectionString (Settings)" DbObjectName="dijieke.dbo.DJK_ORDERS_DETAIL" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[DJK_ORDERS_DETAIL] WHERE (([ORDERS_DETAIL_ID] = @Original_ORDERS_DETAIL_ID) AND ((@IsNull_ORDERS_INFO_ID = 1 AND [ORDERS_INFO_ID] IS NULL) OR ([ORDERS_INFO_ID] = @Original_ORDERS_INFO_ID)) AND ((@IsNull_SEQ_NUM = 1 AND [SEQ_NUM] IS NULL) OR ([SEQ_NUM] = @Original_SEQ_NUM)) AND ((@IsNull_PRODUCT_TYPE = 1 AND [PRODUCT_TYPE] IS NULL) OR ([PRODUCT_TYPE] = @Original_PRODUCT_TYPE)) AND ((@IsNull_PRODUCT_ID = 1 AND [PRODUCT_ID] IS NULL) OR ([PRODUCT_ID] = @Original_PRODUCT_ID)) AND ((@IsNull_PRODUCT_NME = 1 AND [PRODUCT_NME] IS NULL) OR ([PRODUCT_NME] = @Original_PRODUCT_NME)) AND ((@IsNull_IMG_URL = 1 AND [IMG_URL] IS NULL) OR ([IMG_URL] = @Original_IMG_URL)) AND ((@IsNull_PRODUCT_QTY = 1 AND [PRODUCT_QTY] IS NULL) OR ([PRODUCT_QTY] = @Original_PRODUCT_QTY)) AND ((@IsNull_PRODUCT_STRIKE_PRICE = 1 AND [PRODUCT_STRIKE_PRICE] IS NULL) OR ([PRODUCT_STRIKE_PRICE] = @Original_PRODUCT_STRIKE_PRICE)) AND ((@IsNull_DISCOUNT_AMT = 1 AND [DISCOUNT_AMT] IS NULL) OR ([DISCOUNT_AMT] = @Original_DISCOUNT_AMT)) AND ((@IsNull_PRODUCT_SEATS = 1 AND [PRODUCT_SEATS] IS NULL) OR ([PRODUCT_SEATS] = @Original_PRODUCT_SEATS)) AND ((@IsNull_PRODUCT_SERVICE_TYPE = 1 AND [PRODUCT_SERVICE_TYPE] IS NULL) OR ([PRODUCT_SERVICE_TYPE] = @Original_PRODUCT_SERVICE_TYPE)) AND ((@IsNull_IS_COMMENT = 1 AND [IS_COMMENT] IS NULL) OR ([IS_COMMENT] = @Original_IS_COMMENT)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDERS_DETAIL_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_DETAIL_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDERS_INFO_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PRODUCT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PRODUCT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PRODUCT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IMG_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IMG_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IMG_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IMG_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_QTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_QTY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PRODUCT_QTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_QTY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_STRIKE_PRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_STRIKE_PRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PRODUCT_STRIKE_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PRODUCT_STRIKE_PRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DISCOUNT_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SEATS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PRODUCT_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SEATS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SERVICE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PRODUCT_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_COMMENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_COMMENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_COMMENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[DJK_ORDERS_DETAIL] ([ORDERS_DETAIL_ID], [ORDERS_INFO_ID], [SEQ_NUM], [PRODUCT_TYPE], [PRODUCT_ID], [PRODUCT_NME], [IMG_URL], [PRODUCT_QTY], [PRODUCT_STRIKE_PRICE], [DISCOUNT_AMT], [PRODUCT_SEATS], [PRODUCT_SERVICE_TYPE], [IS_COMMENT]) VALUES (@ORDERS_DETAIL_ID, @ORDERS_INFO_ID, @SEQ_NUM, @PRODUCT_TYPE, @PRODUCT_ID, @PRODUCT_NME, @IMG_URL, @PRODUCT_QTY, @PRODUCT_STRIKE_PRICE, @DISCOUNT_AMT, @PRODUCT_SEATS, @PRODUCT_SERVICE_TYPE, @IS_COMMENT);
SELECT ORDERS_DETAIL_ID, ORDERS_INFO_ID, SEQ_NUM, PRODUCT_TYPE, PRODUCT_ID, PRODUCT_NME, IMG_URL, PRODUCT_QTY, PRODUCT_STRIKE_PRICE, DISCOUNT_AMT, PRODUCT_SEATS, PRODUCT_SERVICE_TYPE, IS_COMMENT FROM DJK_ORDERS_DETAIL WHERE (ORDERS_DETAIL_ID = @ORDERS_DETAIL_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDERS_DETAIL_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_DETAIL_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRODUCT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRODUCT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRODUCT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IMG_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IMG_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PRODUCT_QTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_QTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PRODUCT_STRIKE_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PRODUCT_STRIKE_PRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PRODUCT_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SEATS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PRODUCT_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ORDERS_DETAIL_ID, ORDERS_INFO_ID, SEQ_NUM, PRODUCT_TYPE, PRODUCT_ID, PRODUCT_NME, IMG_URL, PRODUCT_QTY, PRODUCT_STRIKE_PRICE, DISCOUNT_AMT, PRODUCT_SEATS, PRODUCT_SERVICE_TYPE, IS_COMMENT FROM dbo.DJK_ORDERS_DETAIL</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[DJK_ORDERS_DETAIL] SET [ORDERS_DETAIL_ID] = @ORDERS_DETAIL_ID, [ORDERS_INFO_ID] = @ORDERS_INFO_ID, [SEQ_NUM] = @SEQ_NUM, [PRODUCT_TYPE] = @PRODUCT_TYPE, [PRODUCT_ID] = @PRODUCT_ID, [PRODUCT_NME] = @PRODUCT_NME, [IMG_URL] = @IMG_URL, [PRODUCT_QTY] = @PRODUCT_QTY, [PRODUCT_STRIKE_PRICE] = @PRODUCT_STRIKE_PRICE, [DISCOUNT_AMT] = @DISCOUNT_AMT, [PRODUCT_SEATS] = @PRODUCT_SEATS, [PRODUCT_SERVICE_TYPE] = @PRODUCT_SERVICE_TYPE, [IS_COMMENT] = @IS_COMMENT WHERE (([ORDERS_DETAIL_ID] = @Original_ORDERS_DETAIL_ID) AND ((@IsNull_ORDERS_INFO_ID = 1 AND [ORDERS_INFO_ID] IS NULL) OR ([ORDERS_INFO_ID] = @Original_ORDERS_INFO_ID)) AND ((@IsNull_SEQ_NUM = 1 AND [SEQ_NUM] IS NULL) OR ([SEQ_NUM] = @Original_SEQ_NUM)) AND ((@IsNull_PRODUCT_TYPE = 1 AND [PRODUCT_TYPE] IS NULL) OR ([PRODUCT_TYPE] = @Original_PRODUCT_TYPE)) AND ((@IsNull_PRODUCT_ID = 1 AND [PRODUCT_ID] IS NULL) OR ([PRODUCT_ID] = @Original_PRODUCT_ID)) AND ((@IsNull_PRODUCT_NME = 1 AND [PRODUCT_NME] IS NULL) OR ([PRODUCT_NME] = @Original_PRODUCT_NME)) AND ((@IsNull_IMG_URL = 1 AND [IMG_URL] IS NULL) OR ([IMG_URL] = @Original_IMG_URL)) AND ((@IsNull_PRODUCT_QTY = 1 AND [PRODUCT_QTY] IS NULL) OR ([PRODUCT_QTY] = @Original_PRODUCT_QTY)) AND ((@IsNull_PRODUCT_STRIKE_PRICE = 1 AND [PRODUCT_STRIKE_PRICE] IS NULL) OR ([PRODUCT_STRIKE_PRICE] = @Original_PRODUCT_STRIKE_PRICE)) AND ((@IsNull_DISCOUNT_AMT = 1 AND [DISCOUNT_AMT] IS NULL) OR ([DISCOUNT_AMT] = @Original_DISCOUNT_AMT)) AND ((@IsNull_PRODUCT_SEATS = 1 AND [PRODUCT_SEATS] IS NULL) OR ([PRODUCT_SEATS] = @Original_PRODUCT_SEATS)) AND ((@IsNull_PRODUCT_SERVICE_TYPE = 1 AND [PRODUCT_SERVICE_TYPE] IS NULL) OR ([PRODUCT_SERVICE_TYPE] = @Original_PRODUCT_SERVICE_TYPE)) AND ((@IsNull_IS_COMMENT = 1 AND [IS_COMMENT] IS NULL) OR ([IS_COMMENT] = @Original_IS_COMMENT)));
SELECT ORDERS_DETAIL_ID, ORDERS_INFO_ID, SEQ_NUM, PRODUCT_TYPE, PRODUCT_ID, PRODUCT_NME, IMG_URL, PRODUCT_QTY, PRODUCT_STRIKE_PRICE, DISCOUNT_AMT, PRODUCT_SEATS, PRODUCT_SERVICE_TYPE, IS_COMMENT FROM DJK_ORDERS_DETAIL WHERE (ORDERS_DETAIL_ID = @ORDERS_DETAIL_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDERS_DETAIL_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_DETAIL_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRODUCT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRODUCT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PRODUCT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IMG_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IMG_URL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PRODUCT_QTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_QTY" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PRODUCT_STRIKE_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PRODUCT_STRIKE_PRICE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PRODUCT_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SEATS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PRODUCT_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IS_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_COMMENT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDERS_DETAIL_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_DETAIL_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ORDERS_INFO_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ORDERS_INFO_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ORDERS_INFO_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SEQ_NUM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SEQ_NUM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PRODUCT_TYPE" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PRODUCT_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PRODUCT_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PRODUCT_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IMG_URL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IMG_URL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IMG_URL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IMG_URL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_QTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_QTY" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PRODUCT_QTY" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_QTY" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_STRIKE_PRICE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_STRIKE_PRICE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_PRODUCT_STRIKE_PRICE" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="PRODUCT_STRIKE_PRICE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DISCOUNT_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_DISCOUNT_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="DISCOUNT_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SEATS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PRODUCT_SEATS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SEATS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PRODUCT_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SERVICE_TYPE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PRODUCT_SERVICE_TYPE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PRODUCT_SERVICE_TYPE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IS_COMMENT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IS_COMMENT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IS_COMMENT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IS_COMMENT" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ORDERS_DETAIL_ID" DataSetColumn="ORDERS_DETAIL_ID" />
              <Mapping SourceColumn="ORDERS_INFO_ID" DataSetColumn="ORDERS_INFO_ID" />
              <Mapping SourceColumn="SEQ_NUM" DataSetColumn="SEQ_NUM" />
              <Mapping SourceColumn="PRODUCT_TYPE" DataSetColumn="PRODUCT_TYPE" />
              <Mapping SourceColumn="PRODUCT_ID" DataSetColumn="PRODUCT_ID" />
              <Mapping SourceColumn="PRODUCT_NME" DataSetColumn="PRODUCT_NME" />
              <Mapping SourceColumn="IMG_URL" DataSetColumn="IMG_URL" />
              <Mapping SourceColumn="PRODUCT_QTY" DataSetColumn="PRODUCT_QTY" />
              <Mapping SourceColumn="PRODUCT_STRIKE_PRICE" DataSetColumn="PRODUCT_STRIKE_PRICE" />
              <Mapping SourceColumn="DISCOUNT_AMT" DataSetColumn="DISCOUNT_AMT" />
              <Mapping SourceColumn="PRODUCT_SEATS" DataSetColumn="PRODUCT_SEATS" />
              <Mapping SourceColumn="PRODUCT_SERVICE_TYPE" DataSetColumn="PRODUCT_SERVICE_TYPE" />
              <Mapping SourceColumn="IS_COMMENT" DataSetColumn="IS_COMMENT" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmDjkOrdersDetail" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmDjkOrdersDetail" msprop:Generator_UserDSName="CDmDjkOrdersDetail">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DJK_ORDERS_DETAIL" msprop:Generator_TableClassName="DJK_ORDERS_DETAILDataTable" msprop:Generator_TableVarName="tableDJK_ORDERS_DETAIL" msprop:Generator_TablePropName="DJK_ORDERS_DETAIL" msprop:Generator_RowDeletingName="DJK_ORDERS_DETAILRowDeleting" msprop:Generator_RowChangingName="DJK_ORDERS_DETAILRowChanging" msprop:Generator_RowEvHandlerName="DJK_ORDERS_DETAILRowChangeEventHandler" msprop:Generator_RowDeletedName="DJK_ORDERS_DETAILRowDeleted" msprop:Generator_UserTableName="DJK_ORDERS_DETAIL" msprop:Generator_RowChangedName="DJK_ORDERS_DETAILRowChanged" msprop:Generator_RowEvArgName="DJK_ORDERS_DETAILRowChangeEvent" msprop:Generator_RowClassName="DJK_ORDERS_DETAILRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ORDERS_DETAIL_ID" msprop:Generator_ColumnVarNameInTable="columnORDERS_DETAIL_ID" msprop:Generator_ColumnPropNameInRow="ORDERS_DETAIL_ID" msprop:Generator_ColumnPropNameInTable="ORDERS_DETAIL_IDColumn" msprop:Generator_UserColumnName="ORDERS_DETAIL_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ORDERS_INFO_ID" msprop:Generator_ColumnVarNameInTable="columnORDERS_INFO_ID" msprop:Generator_ColumnPropNameInRow="ORDERS_INFO_ID" msprop:Generator_ColumnPropNameInTable="ORDERS_INFO_IDColumn" msprop:Generator_UserColumnName="ORDERS_INFO_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SEQ_NUM" msprop:Generator_ColumnVarNameInTable="columnSEQ_NUM" msprop:Generator_ColumnPropNameInRow="SEQ_NUM" msprop:Generator_ColumnPropNameInTable="SEQ_NUMColumn" msprop:Generator_UserColumnName="SEQ_NUM" type="xs:int" minOccurs="0" />
              <xs:element name="PRODUCT_TYPE" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_TYPE" msprop:Generator_ColumnPropNameInRow="PRODUCT_TYPE" msprop:Generator_ColumnPropNameInTable="PRODUCT_TYPEColumn" msprop:Generator_UserColumnName="PRODUCT_TYPE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRODUCT_ID" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_ID" msprop:Generator_ColumnPropNameInRow="PRODUCT_ID" msprop:Generator_ColumnPropNameInTable="PRODUCT_IDColumn" msprop:Generator_UserColumnName="PRODUCT_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRODUCT_NME" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_NME" msprop:Generator_ColumnPropNameInRow="PRODUCT_NME" msprop:Generator_ColumnPropNameInTable="PRODUCT_NMEColumn" msprop:Generator_UserColumnName="PRODUCT_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMG_URL" msprop:Generator_ColumnVarNameInTable="columnIMG_URL" msprop:Generator_ColumnPropNameInRow="IMG_URL" msprop:Generator_ColumnPropNameInTable="IMG_URLColumn" msprop:Generator_UserColumnName="IMG_URL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PRODUCT_QTY" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_QTY" msprop:Generator_ColumnPropNameInRow="PRODUCT_QTY" msprop:Generator_ColumnPropNameInTable="PRODUCT_QTYColumn" msprop:Generator_UserColumnName="PRODUCT_QTY" type="xs:int" minOccurs="0" />
              <xs:element name="PRODUCT_STRIKE_PRICE" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_STRIKE_PRICE" msprop:Generator_ColumnPropNameInRow="PRODUCT_STRIKE_PRICE" msprop:Generator_ColumnPropNameInTable="PRODUCT_STRIKE_PRICEColumn" msprop:Generator_UserColumnName="PRODUCT_STRIKE_PRICE" type="xs:decimal" minOccurs="0" />
              <xs:element name="DISCOUNT_AMT" msprop:Generator_ColumnVarNameInTable="columnDISCOUNT_AMT" msprop:Generator_ColumnPropNameInRow="DISCOUNT_AMT" msprop:Generator_ColumnPropNameInTable="DISCOUNT_AMTColumn" msprop:Generator_UserColumnName="DISCOUNT_AMT" type="xs:decimal" minOccurs="0" />
              <xs:element name="PRODUCT_SEATS" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_SEATS" msprop:Generator_ColumnPropNameInRow="PRODUCT_SEATS" msprop:Generator_ColumnPropNameInTable="PRODUCT_SEATSColumn" msprop:Generator_UserColumnName="PRODUCT_SEATS" type="xs:int" minOccurs="0" />
              <xs:element name="PRODUCT_SERVICE_TYPE" msprop:Generator_ColumnVarNameInTable="columnPRODUCT_SERVICE_TYPE" msprop:Generator_ColumnPropNameInRow="PRODUCT_SERVICE_TYPE" msprop:Generator_ColumnPropNameInTable="PRODUCT_SERVICE_TYPEColumn" msprop:Generator_UserColumnName="PRODUCT_SERVICE_TYPE" type="xs:int" minOccurs="0" />
              <xs:element name="IS_COMMENT" msprop:Generator_ColumnVarNameInTable="columnIS_COMMENT" msprop:Generator_ColumnPropNameInRow="IS_COMMENT" msprop:Generator_ColumnPropNameInTable="IS_COMMENTColumn" msprop:Generator_UserColumnName="IS_COMMENT" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DJK_ORDERS_DETAIL" />
      <xs:field xpath="mstns:ORDERS_DETAIL_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>